Diagram UHCContracts_3

Defincja diagramu UHCContracts_3

Name

UHCContracts_3

Code

UHCContracts_3

Comment

 


Lista tabel diagramu

Name

Code

AccountingSchema

AccountingSchema

AgeCalculationMethod

AgeCalculationMethod

Contract

Contract

ContractData

ContractData

ContractDataHist

ContractDataHist

ContractService

ContractService

ContractServiceKind

ContractServiceKind

ContractServiceRestriction

ContractServiceRestriction

ContractServiceUnitType

ContractServiceUnitType

ContractServMonthlyRestriction

ContractServMonthlyRestriction

DateRestriction

DateRestriction

OrgUnit

OrgUnit

Period

Period

POZPersonnelType

POZPersonnelType

POZSchoolType

POZSchoolType

RatioSchema

RatioSchema


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_36

R_36

Contract

ContractData

ContractID

 

 

R_57

R_57

ContractServiceUnitType

ContractService

ContractServiceUnitTypeID

 

 

R_58

R_58

ContractServiceRestriction

ContractService

ContractServiceRestrictionID

 

 

R_60

R_60

POZSchoolType

ContractServiceRestriction

POZSchoolTypeID

 

 

R_61

R_61

POZPersonnelType

ContractServiceRestriction

POZPersonnelTypeID

 

 

R_62

R_62

DateRestriction

ContractData

DateRestrictionID

 

 

R_64

R_64

AccountingSchema

ContractData

AccountingSchemaID

 

 

R_65

R_65

RatioSchema

ContractData

RatioSchemaID

 

 

R_213

R_213

ContractService

ContractServMonthlyRestriction

ContractServID

 

 

R_311

R_311

ContractService

ContractService

Con_ContractServID

 

 

R_312

R_312

ContractServiceKind

ContractData

ContractServiceKindID

 

 

R_554

R_554

ContractServiceKind

ContractDataHist

ContractServiceKindID

 

 

R_556

R_556

DateRestriction

ContractDataHist

DateRestrictionID

 

 

R_557

R_557

RatioSchema

ContractDataHist

RatioSchemaID

 

 

R_558

R_558

AccountingSchema

ContractDataHist

AccountingSchemaID

 

 

R_559

R_559

Contract

ContractDataHist

ContractID

 

 

R_560

R_560

OrgUnit

ContractDataHist

OrgUnitID

 

 

R_615

R_615

ContractService

ContractDataHist

LumpSumContractServId